Skip Headers

Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Configuring Auxiliary Instance Datafile Names: CONFIGURE AUXNAME

When performing tablespace point-in-time recovery (TSPITR) or duplicating a database using RMAN, you may want to set the names of datafiles in the auxiliary instance before startingthe actual TSPITR or database duplication.

The command for doing so is:

    CONFIGURE AUXNAME FOR datafileSpec TO 'filename';

where `datafileSpec` identifies some datafile by its original name or datafile number, and `filename` is the new path for the specified file.

For example, you might configure a new auxiliary name for datafile 2 as follows:

    CONFIGURE AUXNAME FOR DATAFILE 2 TO '/newdisk/datafiles/df2.df;'

As with other settings, this `CONFIGURE` setting is persistent across RMAN sessions until cleared using `CONFIGURE`... `CLEAR`, as shown here:

    CONFIGURE AUXNAME FOR DATAFILE 2 CLEAR;

If you are performing TSPITR or running the `DUPLICATE` command, then by using `CONFIGURE AUXNAME` you can preconfigure the filenames for use on the auxiliary database without manually specifying the auxiliary filenames during the procedure.

When renaming files with the `DUPLICATE` command, `CONFIGURE AUXNAME` is an alternative to `SET NEWNAME`. The difference is that after you set the `AUXNAME` the first time, you do not need to reset the filename when you issue another `DUPLICATE` command: the `AUXNAME` setting remains in effect until you issue `CONFIGURE AUXNAME` ... `CLEAR`. In contrast, you must reissue the `SET NEWNAME` command every time you rename files.

See Chapter 8, "RMAN Tablespace Point-in-Time Recovery (TSPITR)" for more details on using `CONFIGURE` `AUXNAME` in connection with TSPITR, and Chapter 13, "Creating and Updating Duplicate Databases with RMAN" for more on using `CONFIGURE` `AUXNAME` in performing database duplication.

## Showing the Default Filenames Configured for Auxiliary Channels

To view auxiliary datafile names currently configured for your database, you can use the SHOW AUXNAME command:

    RMAN> SHOW AUXNAME;

Sample output follows:

    RMAN configuration parameters are:
    CONFIGURE AUXNAME FOR DATAFILE '/oracle/oradata/trgt/tools01.dbf' TO
                                   '/tmp/tools01.dbf';